To import files into a general lookup/validation table
iMIS allows you to import tab delimited files into a general lookup/validation table. The import process requires that the file be tab delimited and contain a Code, Expansion, and Description.
- From Customers, select Set up tables > General lookup/validation to open the Set up general lookup/validation window.
- Select New Table from the bottom of the drop-down table list. A window opens and prompts you for the name of the new table.
- Enter the name of the new table in the window that displays.
- Click Save.
- Select Import to display the Importing Tab Delimited Tables… window.
- Click Continue to display the Select import file window.
- Navigate to your import file, and click Open.
- When the import is complete, a dialog box will prompt you to select an additional file.
- Click No to end the import process.
- Click Yes to import another tab delimited file.
- When complete, the Set up general lookup/validation window is displayed.